C:/Projekte/RAIS/dataaccesslayer/DataAccessUtilities.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Xml;


namespace RAIS.DataAccessLayer
{
        public class DataAccessUtilities
        {
                public static String ConnectionString
                {
                        get
                        {
                                ConnectionStringSettings connection =
                                        ConfigurationManager.ConnectionStrings[Constants.RAIS_CONNECTION_STRING_NAME];

                                if (connection != null)
                                {
                   return connection.ConnectionString;
                    //return @"Data Source=TEST-C53F15A305\MSSQL08;Initial Catalog=rais_changed;Persist Security Info=True;User ID=sa;Password=sa";
                    //return @"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\rais_08_06_2011_new\RAIS_Demo_DB_21_05_2011\rais.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
                    //return @"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\rais_db_test\rais.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
                }
                                else
                                {
                                        throw new ApplicationException("Connection string is not specified in config file.");
                                }
                        }
                }

                public static SqlParameter AddParameter(SqlCommand command, string parameterName, object parameterValue)
                {
                        return AddParameter(command, parameterName, parameterValue, ParameterDirection.Input);
                }

                public static SqlParameter AddParameter(SqlCommand command, string parameterName, object parameterValue,
                                                                                                ParameterDirection direction)
                {
                        SqlParameter parameter = command.CreateParameter();
                        parameter.ParameterName = parameterName;
                        parameter.Direction = direction;

                        parameter.SqlDbType = SqlDbType.NVarChar;

                        if (parameterValue == null)
                        {
                                parameterValue = DBNull.Value;
                        }

                        if (parameterValue is byte || parameterValue is byte?)
                        {
                                parameter.SqlDbType = SqlDbType.TinyInt;
                        }
                        else if (parameterValue is int || parameterValue is int?)
                        {
                                parameter.SqlDbType = SqlDbType.Int;
                        }
                        else if (parameterValue is bool || parameterValue is bool?)
                        {
                                parameter.SqlDbType = SqlDbType.TinyInt;
                                parameterValue = ((bool)parameterValue ? 1 : 0);
                        }
                        else if (parameterValue is DateTime || parameterValue is DateTime?)
                        {
                                parameter.SqlDbType = SqlDbType.DateTime;
                        }

                        parameter.Value = parameterValue;

                        command.Parameters.Add(parameter);

                        return parameter;
                }
        }
}